/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.31.234
 Source Server Type    : MySQL
 Source Server Version : 80029 (8.0.29)
 Source Host           : 192.168.31.234:3306
 Source Schema         : iot-pro2

 Target Server Type    : MySQL
 Target Server Version : 80029 (8.0.29)
 File Encoding         : 65001

 Date: 11/09/2024 14:22:46
*/

CREATE DATABASE IF NOT EXISTS `iot-dh`;
use `iot-dh`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for accessory
-- ----------------------------
DROP TABLE IF EXISTS `accessory`;
CREATE TABLE `accessory` (
  `id` varchar(32) NOT NULL COMMENT '配件id',
  `accessory_code` varchar(255) DEFAULT NULL COMMENT '配件编号',
  `accessory_name` varchar(255) DEFAULT NULL COMMENT '配件名称',
  `is_delete` tinyint DEFAULT NULL COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `room_id` varchar(32) DEFAULT NULL COMMENT '分区id',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `sn_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'sn码',
  `sk_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'sk编码',
  `type_detail_id` varchar(32) DEFAULT NULL COMMENT '类型id',
  `sensor_type` varchar(32) DEFAULT NULL COMMENT '传感器⽅式 只有wirelessType为Defence时 此字段才有效，烟感传Smoke 必传',
  `wireless_type` varchar(32) DEFAULT NULL COMMENT '⽆线设备类型 Unknowntype-未知类型；KeyBoard-键盘；Defence-防区；RemoteControl-遥控器；Magnetomer-磁⼒计；AlarmBell-警号；SmartLock-智能锁；Switcher-插座；WirelessRepeater-中继器 必传',
  `model` varchar(32) DEFAULT NULL COMMENT '配件型号 不同配件不⼀样，扫描配件⼆维 码即可查看,烟感传HY-SA21A 必传',
  `accessory_type` varchar(12) DEFAULT NULL COMMENT '1-烟感，2-无线键盘，3-室外信号，4-门磁，5-升级门磁，6-pir相机，7-智能监控相机，8-Alarm KIT',
  `status` tinyint DEFAULT NULL COMMENT '在线状态 1-在线，0-离线',
  `arming_enable` tinyint(1) DEFAULT NULL COMMENT '使能',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='配件管理';

-- ----------------------------
-- Records of accessory
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for alarm_device
-- ----------------------------
DROP TABLE IF EXISTS `alarm_device`;
CREATE TABLE `alarm_device` (
  `id` varchar(255) NOT NULL,
  `device_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `device_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `org_id` bigint DEFAULT NULL,
  `org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `alarm_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `alarm_level` int DEFAULT NULL,
  `alarm_status` int DEFAULT NULL,
  `info` text,
  `alarm_time` bigint DEFAULT NULL,
  `handle_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `handle_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `handle_status` int DEFAULT NULL,
  `channel_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `device_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `device_sub_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` int DEFAULT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `device_operate` int DEFAULT NULL,
  `is_delete` tinyint DEFAULT NULL COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人',
  `type` int DEFAULT NULL COMMENT '推送类型 1告警 2设备上下线 3 设备增删',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of alarm_device
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for alarm_notice_setting
-- ----------------------------
DROP TABLE IF EXISTS `alarm_notice_setting`;
CREATE TABLE `alarm_notice_setting` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
  `country_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区号',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电话号码',
  `sms_notice` tinyint DEFAULT NULL COMMENT '是否短信通知  0:关闭 1:开启',
  `phone_notice` tinyint DEFAULT NULL COMMENT '是否电话通知  0:关闭 1:开启',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `device_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='报警通知设置';

-- ----------------------------
-- Records of alarm_notice_setting
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `username` varchar(20) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `avatar` varchar(200) DEFAULT NULL COMMENT '用户头像地址',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `nickname` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `status` varchar(10) DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `id_card` varchar(50) DEFAULT NULL COMMENT '身份证',
  `region_code` varchar(40) DEFAULT NULL COMMENT '区域',
  `stree_id` varchar(40) DEFAULT NULL COMMENT '街道',
  `community_id` varchar(40) DEFAULT NULL COMMENT '小区',
  `create_by` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_name` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='企业用户表';

-- ----------------------------
-- Records of company
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for company_user
-- ----------------------------
DROP TABLE IF EXISTS `company_user`;
CREATE TABLE `company_user` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `user_id` varchar(20) DEFAULT NULL COMMENT '用户id',
  `company_id` varchar(100) DEFAULT NULL COMMENT '公司id',
  `create_by` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户公司关联表';

-- ----------------------------
-- Records of company_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for consumer
-- ----------------------------
DROP TABLE IF EXISTS `consumer`;
CREATE TABLE `consumer` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `username` varchar(20) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `avatar` varchar(200) DEFAULT NULL COMMENT '用户头像地址',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `nickname` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `status` varchar(10) DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `id_card` varchar(50) DEFAULT NULL COMMENT '身份证',
  `region_code` varchar(40) DEFAULT NULL COMMENT '区域',
  `stree_id` varchar(40) DEFAULT NULL COMMENT '街道',
  `community_id` varchar(40) DEFAULT NULL COMMENT '小区',
  `create_by` varchar(32) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `fcm_token` varchar(255) DEFAULT NULL COMMENT 'fcm token',
  `country_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '区号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_name` (`username`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='app用户表';

-- ----------------------------
-- Records of consumer
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device
-- ----------------------------
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device` (
  `id` varchar(32) NOT NULL COMMENT '设备id',
  `device_code` varchar(255) DEFAULT NULL COMMENT '设备编号',
  `device_name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `mode` varchar(255) DEFAULT NULL COMMENT '布撤防模式',
  `wifi_mode` varchar(255) DEFAULT NULL COMMENT 'wifi模式',
  `is_delete` tinyint DEFAULT NULL COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `site_id` varchar(32) DEFAULT NULL COMMENT '站点id',
  `device_type_id` varchar(32) DEFAULT NULL COMMENT '设备类型id',
  `sn_code` varchar(32) DEFAULT NULL COMMENT 'sn码',
  `description` varchar(255) DEFAULT NULL,
  `sk_code` varchar(32) DEFAULT NULL COMMENT 'sk编码',
  `x_value` varchar(12) DEFAULT NULL COMMENT '平面图x值',
  `y_value` varchar(12) DEFAULT NULL COMMENT '平面图y值',
  `status` tinyint DEFAULT NULL COMMENT '在线状态 1-在线，0-离线',
  `mode_type` tinyint DEFAULT '2' COMMENT '布防状态：1-出门，2-在家，3-撤防',
  `not_alarm_day` int DEFAULT NULL COMMENT '设置未报警提醒天数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='设备管理';

-- ----------------------------
-- Records of device
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_attribute
-- ----------------------------
DROP TABLE IF EXISTS `device_attribute`;
CREATE TABLE `device_attribute` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `device_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户id',
  `device_type_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门id',
  `attribute` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报文：{"electrical": "58",  "temperature" :"23"}',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of device_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_attribute_alarm
-- ----------------------------
DROP TABLE IF EXISTS `device_attribute_alarm`;
CREATE TABLE `device_attribute_alarm` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `device_type_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户id',
  `device_type_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部门id',
  `attribute` varchar(45) DEFAULT NULL COMMENT '报警字段',
  `alarm_value` varchar(45) DEFAULT NULL COMMENT '报警值',
  `judge_type` varchar(45) DEFAULT NULL COMMENT '判断类型：\\n1、大于\\n2、大于等于\\n3、等于\\n4、小于等于\\n5、小于',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='设备报警设置';

-- ----------------------------
-- Records of device_attribute_alarm
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record`;
CREATE TABLE `device_error_record` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '报警id',
  `device_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备id  (设备sn码)',
  `device_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备名称',
  `alarm_hub_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警名称',
  `error_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警类型  (类型是否添加配置表？) 一个设备报警会不会回调多次 处理完回调数据格式判断',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警状态  (处理结果)',
  `error_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警信息',
  `room_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分区id',
  `room_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '分区名称',
  `site_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点id',
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点名称',
  `error_time` datetime DEFAULT NULL COMMENT '报警时间',
  `fixing_time` datetime DEFAULT NULL COMMENT '处理时间',
  `fixing_staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理人姓名',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  `is_read` tinyint DEFAULT NULL COMMENT '是否已读 0：未读  1：已读',
  `type` int DEFAULT NULL COMMENT '1:报警  2:故障 3:事件 4:通知',
  `consumer_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'app用户id',
  `pic_urls` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `accessory_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配件类型',
  `accessory_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配件sn',
  `device_type` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1-ipc,2-网关,3-其他,99配件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备报警记录表 (后续加一个app用户id区分)';

-- ----------------------------
-- Records of device_error_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record_app_push
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record_app_push`;
CREATE TABLE `device_error_record_app_push` (
  `message` varchar(500) DEFAULT NULL COMMENT 'app告警推送记录表'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='app告警推送记录表';

-- ----------------------------
-- Records of device_error_record_app_push
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record_dict
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record_dict`;
CREATE TABLE `device_error_record_dict` (
  `id` varchar(32) NOT NULL COMMENT 'id',
  `type` int NOT NULL COMMENT '1:报警  2:故障',
  `msg_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '报警\\故障类型值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='报警/故障字典表';

-- ----------------------------
-- Records of device_error_record_dict
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record_message
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record_message`;
CREATE TABLE `device_error_record_message` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `der_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警表id',
  `error_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '报警类型-  描述',
  `site_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点id',
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点名称',
  `error_time` datetime DEFAULT NULL COMMENT '报警时间',
  `is_read` tinyint DEFAULT NULL COMMENT '是否已读 0：未读  1：已读',
  `type` int DEFAULT NULL COMMENT '1:报警  2:故障 3:事件 4:通知',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='告警消息web站内信';

-- ----------------------------
-- Records of device_error_record_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record_read
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record_read`;
CREATE TABLE `device_error_record_read` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `consumer_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'app用户id',
  `der_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'device_error_record.id',
  `is_read` tinyint NOT NULL COMMENT '是否已读 0：未读  1：已读',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of device_error_record_read
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_error_record_transition
-- ----------------------------
DROP TABLE IF EXISTS `device_error_record_transition`;
CREATE TABLE `device_error_record_transition` (
  `id` varchar(32) NOT NULL COMMENT 'id',
  `category` varchar(12) DEFAULT NULL COMMENT '1-ipc,2-网关,3-其他,99配件',
  `accessory_type` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1-烟感，2-无线键盘，3-室外信号，4-门磁，5-升级门磁，6-pir相机，7-智能监控相机，8-Alarm KIT',
  `error_type` varchar(255) DEFAULT NULL COMMENT '大华推过来的值',
  `new_error_type` varchar(255) DEFAULT NULL COMMENT '转换后的值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='设备记录翻译';

-- ----------------------------
-- Records of device_error_record_transition
-- ----------------------------
BEGIN;
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('1', '1', NULL, 'storageAbnormal', 'SD Card Error');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('10', '2', '6', 'SensorAbnormal', 'Tamper Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('11', '2', '2', 'Panic', 'Panic Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('2', '2', '4', 'AlarmInputSourceSignal', 'Intrusion Recovery of Door Detector');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('3', '2', '4', 'AlarmLocal', 'Intrusion Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('4', '2', '4', 'SensorAbnormal', 'Tamper Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('5', '2', '5', 'AlarmInputSourceSignal', 'Intrusion Recovery of Door Detector');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('6', '2', '5', 'AlarmLocal', 'Intrusion Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('7', '2', '5', 'SensorAbnormal', 'Tamper Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('8', '2', '1', 'Fire', 'Fire Alarm');
INSERT INTO `device_error_record_transition` (`id`, `category`, `accessory_type`, `error_type`, `new_error_type`) VALUES ('9', '2', '6', 'alarmlocal', 'Motion Detected');
COMMIT;

DROP TABLE IF EXISTS `device_error_record_config`;
CREATE TABLE `device_error_record_config`  (
       `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
       `device_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备sn码',
       `protocol_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '协议类型：SIA_DC09\":DC09协议;\"Private\":私有协议',
       `primary_address_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主选地址ip',
       `primary_address_port` int(0) NULL DEFAULT NULL COMMENT '主选地址端口',
       `alternative_address_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备用地址ip',
       `alternative_address_port` int(0) NULL DEFAULT NULL COMMENT '备用地址端口',
       `ip_protocol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip协议(暂无)',
       `heartbeat_interval` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '检测信号间隔(暂无)',
       `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '中央账号',
       `report_events` int(0) NULL DEFAULT NULL COMMENT '重传期限，发送失败的消息保留超过此期限则不再重传；默认：0-永久；单位：分钟',
       `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
       `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
       `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
       `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
       `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
       PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '告警配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of device_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_type
-- ----------------------------
DROP TABLE IF EXISTS `device_type`;
CREATE TABLE `device_type` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '设备类型编码',
  `type_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备名称',
  `sort` int DEFAULT '0' COMMENT '排序',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `code_UNIQUE` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备类型表（删除）';

-- ----------------------------
-- Records of device_type
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_type_attribute
-- ----------------------------
DROP TABLE IF EXISTS `device_type_attribute`;
CREATE TABLE `device_type_attribute` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `device_type_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户id',
  `device_type_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '部门id',
  `attribute` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '属性：[{"code": "electrical",  "name" :"电量", "type": "num" ,   "range": "1,10" ,   "defaultAlarm": "6" }]',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户与部门关联表';

-- ----------------------------
-- Records of device_type_attribute
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for device_type_detail
-- ----------------------------
DROP TABLE IF EXISTS `device_type_detail`;
CREATE TABLE `device_type_detail` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备类型编码',
  `type_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备名称',
  `sub_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子设备类型编码',
  `sub_type_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子设备名称',
  `sort` int DEFAULT '0' COMMENT '排序',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `category` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1-ipc,2-网关,3-其他,99配件',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='设备类型明细表';

-- ----------------------------
-- Records of device_type_detail
-- ----------------------------
BEGIN;
INSERT INTO `device_type_detail` (`id`, `code`, `type_name`, `sub_code`, `sub_type_name`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `category`) VALUES ('37', '2004', '智能预警', '200418', 'Alarm Hub', 0, NULL, NULL, NULL, NULL, NULL, '2');
INSERT INTO `device_type_detail` (`id`, `code`, `type_name`, `sub_code`, `sub_type_name`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `category`) VALUES ('62', '2007', '视频设备', '20071', 'IPC', 0, NULL, NULL, NULL, NULL, NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for industry
-- ----------------------------
DROP TABLE IF EXISTS `industry`;
CREATE TABLE `industry` (
  `id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `industry_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '行业名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='行业类型';

-- ----------------------------
-- Records of industry
-- ----------------------------
BEGIN;
INSERT INTO `industry` (`id`, `industry_name`) VALUES ('1', 'finance');
INSERT INTO `industry` (`id`, `industry_name`) VALUES ('2', 'agriculture');
INSERT INTO `industry` (`id`, `industry_name`) VALUES ('3', 'computer');
COMMIT;

-- ----------------------------
-- Table structure for ipc_accessory
-- ----------------------------
DROP TABLE IF EXISTS `ipc_accessory`;
CREATE TABLE `ipc_accessory` (
  `id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `alarm_hub_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '网关设备id',
  `alarm_hub_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '网关设备sn',
  `ipc_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'ipc设备id',
  `ipc_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'ipc设备sn',
  `accessory_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配件id',
  `accessory_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配件sn',
  `is_delete` tinyint DEFAULT '0' COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='ipc关联配件表';

-- ----------------------------
-- Records of ipc_accessory
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` varchar(32) NOT NULL COMMENT '消息id',
  `title` varchar(255) DEFAULT NULL COMMENT '消息标题',
  `content` varchar(255) DEFAULT NULL COMMENT '消息内容',
  `type` varchar(255) DEFAULT NULL COMMENT '消息类型：all、所有消息；alarm、报警类消息；malfunction、故障类消息；armed mode、布撤防切换类消息；system related、操作日志类消息',
  `port` varchar(20) DEFAULT NULL COMMENT '消息端口：web：web端，app：app端',
  `status` varchar(20) DEFAULT NULL COMMENT '状态： unread：未读，read：已读',
  `is_delete` tinyint DEFAULT '0' COMMENT '是否删除：1：是，0：否',
  `create_date` date DEFAULT NULL COMMENT '创建日期',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='消息管理';

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` varchar(32) NOT NULL COMMENT '消息id',
  `title` varchar(100) DEFAULT NULL COMMENT '消息标题',
  `content` varchar(255) DEFAULT NULL COMMENT '消息内容',
  `type` varchar(50) DEFAULT NULL COMMENT '消息类型：all、所有消息；alarm、报警类消息；malfunction、故障类消息；armed mode、布撤防切换类消息；system related、操作日志类消息',
  `port` varchar(20) DEFAULT NULL COMMENT 'Android、IOS',
  `push_parameter` varchar(2000) DEFAULT NULL COMMENT '推送参数',
  `status` int DEFAULT NULL COMMENT '状态： 0：推送成功，1：推送失败',
  `result` varchar(2000) DEFAULT '0' COMMENT '消息推送结果',
  `create_date` date DEFAULT NULL COMMENT '创建日期',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='通知';

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for rental_device
-- ----------------------------
DROP TABLE IF EXISTS `rental_device`;
CREATE TABLE `rental_device` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `consumer_id` varchar(255) DEFAULT NULL COMMENT 'app用户id',
  `device_id` varchar(32) DEFAULT NULL COMMENT '设备id',
  `room_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分区id',
  `start_date` datetime DEFAULT NULL COMMENT '开始时间',
  `end_date` datetime DEFAULT NULL COMMENT '结束时间',
  `is_delete` tinyint DEFAULT '0' COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='租赁设备管理';

-- ----------------------------
-- Records of rental_device
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '房间id',
  `room_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '房间名称',
  `room_picture` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '房间图片',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '描述',
  `is_delete` tinyint DEFAULT '0' COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `room_address` varchar(100) DEFAULT NULL COMMENT '房间地址',
  `device_id` varchar(32) DEFAULT NULL COMMENT '设备id',
  `room_code` int DEFAULT NULL COMMENT '分区code',
  `mode` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分区布撤防模式："T"-Total外出布防模式;"p1"-Partial1在家布防模式;"D"-撤防',
  `industry_type` varchar(32) DEFAULT NULL COMMENT '行业类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='房间管理';

-- ----------------------------
-- Records of room
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for room_mode_timed_task
-- ----------------------------
DROP TABLE IF EXISTS `room_mode_timed_task`;
CREATE TABLE `room_mode_timed_task` (
  `id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
  `task_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '定时任务id',
  `room_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分区id',
  `mode` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分区布撤防模式："T"-Total外出布防模式;"p1"-Partial1在家布防模式;"D"-撤防',
  `time` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时分秒 格式  22:00:00',
  `week` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '星期一2 星期二3 星期三4 星期四5 星期五6 星期六7 星期天1  多个逗号分隔 例: 2,3,4',
  `is_delete` tinyint DEFAULT '0' COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='定时布撤防任务表';

-- ----------------------------
-- Records of room_mode_timed_task
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sdk_error_record
-- ----------------------------
DROP TABLE IF EXISTS `sdk_error_record`;
CREATE TABLE `sdk_error_record` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户主键',
  `ip_address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'ip地址',
  `input_parameters` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '接口入参json字符串',
  `sdk_address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '调用sdk的接口地址',
  `error_info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '错误信息包含code、msg、data',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sdk_error_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for site
-- ----------------------------
DROP TABLE IF EXISTS `site`;
CREATE TABLE `site` (
  `id` varchar(32) NOT NULL COMMENT '站点id',
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点名称',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
  `time_zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '时区',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `is_delete` tinyint DEFAULT NULL COMMENT '是否删除：1：是，0：否',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  `lon` double(10,6) DEFAULT NULL COMMENT '经度',
  `lat` double(10,6) DEFAULT NULL COMMENT '纬度',
  `picture_id` varchar(32) DEFAULT NULL COMMENT '图片id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='站点管理';

-- ----------------------------
-- Records of site
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户主键',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(1000) DEFAULT NULL COMMENT 'logo图片',
  `system_name` varchar(200) DEFAULT NULL COMMENT '系统名称',
  `privacy` text COMMENT '隐私协议',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统配置';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `logo`, `system_name`, `privacy`) VALUES ('1', 'admin', '2024-08-08 12:27:22', '741295987@qq.com', '2024-09-03 14:58:26', NULL, 'https://vprotect.aiot-dev.com/iot-web/backend/sys/file/viewFile/3b62df6fa3784d2faadd5afa656ff4b1.jpg', 'Vprotect-AOP', 'I. General Provisions\n1.1 The user must agree to the terms of this agreement and complete the entire registration process as prompted on the page. By checking the \"I have read and accept\" box during the registration process, the user agrees to all the terms under this agreement with [Product Name] and fully accepts all the terms under this agreement.\n1.2 After successful registration, [Product Name] will provide each user with a user account and corresponding password, which the user is responsible for safeguarding. The user is legally responsible for all activities and events conducted through their user account.\n1.3 Users may use the individual services provided by different channels of [Product Name]. When using each individual service, the user’s actions will be deemed as consent to the terms of service for that specific service and the various announcements issued by [Product Name] in that individual service.\nII. Registration Information and Privacy Protection\n2.1 The ownership of the [Product Name] account (i.e., [Product Name] User ID) belongs to [Product Name]. After the user completes the registration process, they obtain the right to use the [Product Name] account. All original information entered will be considered registration information. [Product Name] is not responsible for any issues caused by false registration information and the consequences arising from such issues.\n2.2 Users should not transfer or lend their account and password to others. If a user discovers that their account is being used illegally by someone else, they should immediately notify [Product Name]. [Product Name] is not responsible for any illegal use of the account or password caused by hacking or the user\'s negligence in safeguarding them.\n2.3 [Product Name] will not publicly disclose or provide a single user\'s registration information to third parties unless:\nPrior explicit authorization from the user is obtained;\nIt is necessary to disclose your personal information to provide the product or service you have requested;\nIt');
COMMIT;

-- ----------------------------
-- Table structure for sys_country_info
-- ----------------------------
DROP TABLE IF EXISTS `sys_country_info`;
CREATE TABLE `sys_country_info` (
  `id` varchar(32) NOT NULL COMMENT '主键（国家）id',
  `country_code` varchar(255) DEFAULT NULL COMMENT '区号',
  `country_name_en` varchar(255) DEFAULT NULL COMMENT '国家（英文）',
  `country_name_cn` varchar(255) DEFAULT NULL COMMENT '国家（中文）',
  `ab` varchar(255) DEFAULT NULL COMMENT '标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='国际区号表';

-- ----------------------------
-- Records of sys_country_info
-- ----------------------------
BEGIN;
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100006', '244', 'Angola', '安哥拉', 'AO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100007', '93', 'Afghanistan', '阿富汗', 'AF');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100008', '355', 'Albania', '阿尔巴尼亚', 'AL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100009', '213', 'Algeria', '阿尔及利亚', 'DZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100010', '376', 'Andorra', '安道尔共和国', 'AD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100011', '1264', 'Anguilla', '安圭拉岛', 'AI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100012', '1268', 'Antigua and Barbuda', '安提瓜和巴布达', 'AG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100013', '54', 'Argentina', '阿根廷', 'AR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100014', '374', 'Armenia', '亚美尼亚', 'AM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100015', '247', 'Ascension', '阿森松', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100016', '61', 'Australia', '澳大利亚', 'AU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100017', '43', 'Austria', '奥地利', 'AT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100018', '994', 'Azerbaijan', '阿塞拜疆', 'AZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100019', '1242', 'Bahamas', '巴哈马', 'BS');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100020', '973', 'Bahrain', '巴林', 'BH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100021', '880', 'Bangladesh', '孟加拉国', 'BD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100022', '1246', 'Barbados', '巴巴多斯', 'BB');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100023', '375', 'Belarus', '白俄罗斯', 'BY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100024', '32', 'Belgium', '比利时', 'BE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100025', '501', 'Belize', '伯利兹', 'BZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100026', '229', 'Benin', '贝宁', 'BJ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100027', '1441', 'Bermuda Is.', '百慕大群岛', 'BM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100028', '591', 'Bolivia', '玻利维亚', 'BO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100029', '267', 'Botswana', '博茨瓦纳', 'BW');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100030', '55', 'Brazil', '巴西', 'BR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100031', '673', 'Brunei', '文莱', 'BN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100032', '359', 'Bulgaria', '保加利亚', 'BG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100033', '226', 'Burkina-faso', '布基纳法索', 'BF');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100034', '95', 'Burma', '缅甸', 'MM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100035', '257', 'Burundi', '布隆迪', 'BI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100036', '237', 'Cameroon', '喀麦隆', 'CM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100037', '1', 'Canada', '加拿大', 'CA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100038', '1345', 'Cayman Is.', '开曼群岛', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100039', '236', 'Central African Republic', '中非共和国', 'CF');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100040', '235', 'Chad', '乍得', 'TD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100041', '56', 'Chile', '智利', 'CL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100042', '86', 'China', '中国', 'CN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100043', '57', 'Colombia', '哥伦比亚', 'CO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100044', '242', 'Congo', '刚果', 'CG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100045', '682', 'Cook Is.', '库克群岛', 'CK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100046', '506', 'Costa Rica', '哥斯达黎加', 'CR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100047', '53', 'Cuba', '古巴', 'CU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100048', '357', 'Cyprus', '塞浦路斯', 'CY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100049', '420', 'Czech Republic', '捷克', 'CZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100050', '45', 'Denmark', '丹麦', 'DK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100051', '253', 'Djibouti', '吉布提', 'DJ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100052', '1890', 'Dominica Rep.', '多米尼加共和国', 'DO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100053', '593', 'Ecuador', '厄瓜多尔', 'EC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100054', '20', 'Egypt', '埃及', 'EG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100055', '503', 'EI Salvador', '萨尔瓦多', 'SV');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100056', '372', 'Estonia', '爱沙尼亚', 'EE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100057', '251', 'Ethiopia', '埃塞俄比亚', 'ET');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100058', '679', 'Fiji', '斐济', 'FJ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100059', '358', 'Finland', '芬兰', 'FI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100060', '33', 'France', '法国', 'FR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100061', '594', 'French Guiana', '法属圭亚那', 'GF');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100062', '241', 'Gabon', '加蓬', 'GA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100063', '220', 'Gambia', '冈比亚', 'GM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100064', '995', 'Georgia', '格鲁吉亚', 'GE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100065', '49', 'Germany', '德国', 'DE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100066', '233', 'Ghana', '加纳', 'GH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100067', '350', 'Gibraltar', '直布罗陀', 'GI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100068', '30', 'Greece', '希腊', 'GR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100069', '1809', 'Grenada', '格林纳达', 'GD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100070', '1671', 'Guam', '关岛', 'GU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100071', '502', 'Guatemala', '危地马拉', 'GT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100072', '224', 'Guinea', '几内亚', 'GN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100073', '592', 'Guyana', '圭亚那', 'GY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100074', '509', 'Haiti', '海地', 'HT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100075', '504', 'Honduras', '洪都拉斯', 'HN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100076', '852', 'Hongkong', '香港', 'HK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100077', '36', 'Hungary', '匈牙利', 'HU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100078', '354', 'Iceland', '冰岛', 'IS');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100079', '91', 'India', '印度', 'IN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100080', '62', 'Indonesia', '印度尼西亚', 'ID');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100081', '98', 'Iran', '伊朗', 'IR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100082', '964', 'Iraq', '伊拉克', 'IQ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100083', '353', 'Ireland', '爱尔兰', 'IE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100084', '972', 'Israel', '以色列', 'IL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100085', '39', 'Italy', '意大利', 'IT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100086', '225', 'Ivory Coast', '科特迪瓦', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100087', '1876', 'Jamaica', '牙买加', 'JM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100088', '81', 'Japan', '日本', 'JP');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100089', '962', 'Jordan', '约旦', 'JO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100090', '855', 'Kampuchea (Cambodia )', '柬埔寨', 'KH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100091', '327', 'Kazakstan', '哈萨克斯坦', 'KZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100092', '254', 'Kenya', '肯尼亚', 'KE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100093', '82', 'Korea', '韩国', 'KR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100094', '965', 'Kuwait', '科威特', 'KW');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100095', '331', 'Kyrgyzstan', '吉尔吉斯坦', 'KG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100096', '856', 'Laos', '老挝', 'LA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100097', '371', 'Latvia', '拉脱维亚', 'LV');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100098', '961', 'Lebanon', '黎巴嫩', 'LB');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100099', '266', 'Lesotho', '莱索托', 'LS');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100100', '231', 'Liberia', '利比里亚', 'LR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100101', '218', 'Libya', '利比亚', 'LY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100102', '423', 'Liechtenstein', '列支敦士登', 'LI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100103', '370', 'Lithuania', '立陶宛', 'LT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100104', '352', 'Luxembourg', '卢森堡', 'LU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100105', '853', 'Macao', '澳门', 'MO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100106', '261', 'Madagascar', '马达加斯加', 'MG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100107', '265', 'Malawi', '马拉维', 'MW');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100108', '60', 'Malaysia', '马来西亚', 'MY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100109', '960', 'Maldives', '马尔代夫', 'MV');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100110', '223', 'Mali', '马里', 'ML');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100111', '356', 'Malta', '马耳他', 'MT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100112', '1670', 'Mariana Is', '马里亚那群岛', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100113', '596', 'Martinique', '马提尼克', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100114', '230', 'Mauritius', '毛里求斯', 'MU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100115', '52', 'Mexico', '墨西哥', 'MX');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100116', '373', 'Moldova, Republic of', '摩尔多瓦', 'MD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100117', '377', 'Monaco', '摩纳哥', 'MC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100118', '976', 'Mongolia', '蒙古', 'MN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100119', '1664', 'Montserrat Is', '蒙特塞拉特岛', 'MS');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100120', '212', 'Morocco', '摩洛哥', 'MA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100121', '258', 'Mozambique', '莫桑比克', 'MZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100122', '264', 'Namibia', '纳米比亚', 'NA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100123', '674', 'Nauru', '瑙鲁', 'NR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100124', '977', 'Nepal', '尼泊尔', 'NP');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100125', '599', 'Netheriands Antilles', '荷属安的列斯', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100126', '31', 'Netherlands', '荷兰', 'NL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100127', '64', 'New Zealand', '新西兰', 'NZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100128', '505', 'Nicaragua', '尼加拉瓜', 'NI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100129', '227', 'Niger', '尼日尔', 'NE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100130', '234', 'Nigeria', '尼日利亚', 'NG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100131', '850', 'North Korea', '朝鲜', 'KP');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100132', '47', 'Norway', '挪威', 'NO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100133', '968', 'Oman', '阿曼', 'OM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100134', '92', 'Pakistan', '巴基斯坦', 'PK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100135', '507', 'Panama', '巴拿马', 'PA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100136', '675', 'Papua New Cuinea', '巴布亚新几内亚', 'PG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100137', '595', 'Paraguay', '巴拉圭', 'PY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100138', '51', 'Peru', '秘鲁', 'PE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100139', '63', 'Philippines', '菲律宾', 'PH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100140', '48', 'Poland', '波兰', 'PL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100141', '689', 'French Polynesia', '法属玻利尼西亚', 'PF');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100142', '351', 'Portugal', '葡萄牙', 'PT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100143', '1787', 'Puerto Rico', '波多黎各', 'PR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100144', '974', 'Qatar', '卡塔尔', 'QA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100145', '262', 'Reunion', '留尼旺', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100146', '40', 'Romania', '罗马尼亚', 'RO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100147', '7', 'Russia', '俄罗斯', 'RU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100148', '1758', 'Saint Lueia', '圣卢西亚', 'LC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100149', '1784', 'Saint Vincent', '圣文森特岛', 'VC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100150', '684', 'Samoa Eastern', '东萨摩亚(美)', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100151', '685', 'Samoa Western', '西萨摩亚', '');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100152', '378', 'San Marino', '圣马力诺', 'SM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100153', '239', 'Sao Tome and Principe', '圣多美和普林西比', 'ST');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100154', '966', 'Saudi Arabia', '沙特阿拉伯', 'SA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100155', '221', 'Senegal', '塞内加尔', 'SN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100156', '248', 'Seychelles', '塞舌尔', 'SC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100157', '232', 'Sierra Leone', '塞拉利昂', 'SL');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100158', '65', 'Singapore', '新加坡', 'SG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100159', '421', 'Slovakia', '斯洛伐克', 'SK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100160', '386', 'Slovenia', '斯洛文尼亚', 'SI');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100161', '677', 'Solomon Is', '所罗门群岛', 'SB');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100162', '252', 'Somali', '索马里', 'SO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100163', '27', 'South Africa', '南非', 'ZA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100164', '34', 'Spain', '西班牙', 'ES');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100165', '94', 'Sri Lanka', '斯里兰卡', 'LK');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100166', '1758', 'St.Lucia', '圣卢西亚', 'LC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100167', '1784', 'St.Vincent', '圣文森特', 'VC');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100168', '249', 'Sudan', '苏丹', 'SD');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100169', '597', 'Suriname', '苏里南', 'SR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100170', '268', 'Swaziland', '斯威士兰', 'SZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100171', '46', 'Sweden', '瑞典', 'SE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100172', '41', 'Switzerland', '瑞士', 'CH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100173', '963', 'Syria', '叙利亚', 'SY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100174', '886', 'Taiwan', '台湾省', 'TW');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100175', '992', 'Tajikstan', '塔吉克斯坦', 'TJ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100176', '255', 'Tanzania', '坦桑尼亚', 'TZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100177', '66', 'Thailand', '泰国', 'TH');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100178', '228', 'Togo', '多哥', 'TG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100179', '676', 'Tonga', '汤加', 'TO');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100180', '1809', 'Trinidad and Tobago', '特立尼达和多巴哥', 'TT');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100181', '216', 'Tunisia', '突尼斯', 'TN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100182', '90', 'Turkey', '土耳其', 'TR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100183', '993', 'Turkmenistan', '土库曼斯坦', 'TM');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100184', '256', 'Uganda', '乌干达', 'UG');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100185', '380', 'Ukraine', '乌克兰', 'UA');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100186', '971', 'United Arab Emirates', '阿拉伯联合酋长国', 'AE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100187', '44', 'United Kiongdom', '英国', 'GB');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100188', '1', 'United States of America', '美国', 'US');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100189', '598', 'Uruguay', '乌拉圭', 'UY');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100190', '233', 'Uzbekistan', '乌兹别克斯坦', 'UZ');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100191', '58', 'Venezuela', '委内瑞拉', 'VE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100192', '84', 'Vietnam', '越南', 'VN');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100193', '967', 'Yemen', '也门', 'YE');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100194', '381', 'Yugoslavia', '南斯拉夫', 'YU');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100195', '263', 'Zimbabwe', '津巴布韦', 'ZW');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100196', '243', 'Zaire', '扎伊尔', 'ZR');
INSERT INTO `sys_country_info` (`id`, `country_code`, `country_name_en`, `country_name_cn`, `ab`) VALUES ('100197', '260', 'Zambia', '赞比亚', 'ZM');
COMMIT;

-- ----------------------------
-- Table structure for sys_depart
-- ----------------------------
DROP TABLE IF EXISTS `sys_depart`;
CREATE TABLE `sys_depart` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户主键',
  `parent_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父级id',
  `depart_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门名称',
  `depart_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门类型',
  `depart_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门编码',
  `leader` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '负责人',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电话',
  `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `sort` int DEFAULT '0' COMMENT '排序',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `full_depart_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `full_depart_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `depart_code` (`depart_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统组织部门表';

-- ----------------------------
-- Records of sys_depart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'id',
  `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父级di',
  `dict_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典名称',
  `dict_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典编码',
  `dict_value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '字典数据值',
  `sort` int unsigned DEFAULT '0' COMMENT '排序',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='系统字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `parent_id`, `dict_name`, `dict_code`, `dict_value`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('0e884eb05127e8c52f32f15b984b07ba', '0', 'Industry_type', 'Industry_type', NULL, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `parent_id`, `dict_name`, `dict_code`, `dict_value`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1e998389c5e6d855a17377a2cce3f812', '0e884eb05127e8c52f32f15b984b07ba', 'retail', 'BFC7CW', NULL, 0, 'ENABLE', 'wangqunzhi112@gmail.com', '2024-08-20 19:25:12', 'xionghaigang55@gmail.com', '2024-08-26 23:54:07', NULL);
INSERT INTO `sys_dict` (`id`, `parent_id`, `dict_name`, `dict_code`, `dict_value`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('3a80b51071a1af26fd9b5fda476c93ba', '0e884eb05127e8c52f32f15b984b07ba', 'bank', 'GD0BN4', NULL, 0, 'ENABLE', 'wangqunzhi112@gmail.com', '2024-08-21 09:39:24', '741295987@qq.com', '2024-08-28 10:03:15', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_email_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_email_config`;
CREATE TABLE `sys_email_config` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户主键',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `from_user` varchar(100) DEFAULT NULL COMMENT '发件人',
  `host` varchar(100) DEFAULT NULL COMMENT '邮件服务器SMTP地址',
  `pass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  `port` int DEFAULT NULL COMMENT '端口',
  `user` varchar(100) DEFAULT NULL COMMENT '发件者用户名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='邮箱配置';

-- ----------------------------
-- Records of sys_email_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_email_config` (`id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `from_user`, `host`, `pass`, `port`, `user`) VALUES ('c201fd3f2f5ff951fc035721b698fab6', '15223221690@163.com', '2024-08-15 15:13:32', NULL, NULL, NULL, 'qinjianhuiwf@gmail.com', 'smtp.gmail.com', 'C6E6DE298B1834C34F9848598DB69AB36CCB19A4D4C317D1BDB24C11C0C82217', 465, 'qinjianhuiwf');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'id',
  `original_filename` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '源文件名',
  `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件名',
  `ext_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扩展名',
  `file_size` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '文件大小',
  `file_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件路径',
  `start_time` datetime DEFAULT NULL COMMENT '上传开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '上传结束时间',
  `biz_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
  `biz_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务id',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统文件表';

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务名称',
  `invoke_target` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'Cron表达式',
  `is_delete` tinyint DEFAULT '0' COMMENT '删除标志 0：正常 1：删除',
  `misfire_policy` tinyint DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` tinyint DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` tinyint DEFAULT '0' COMMENT '任务状态  0：正常  1：暂停',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id',
  `job_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务id',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '任务名称',
  `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '调用目标字符串',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '失败信息',
  `times` decimal(10,4) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `job_id` (`job_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务日志';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志类别',
  `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '执行参数',
  `handle_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作类型',
  `handle_note` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作备注',
  `handle_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` int DEFAULT NULL COMMENT '耗时',
  `handle_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作ip',
  `success` tinyint DEFAULT NULL COMMENT '是否成功',
  `code` int DEFAULT NULL COMMENT '状态码',
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '处理信息',
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色名',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `site_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点名称',
  `device_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备id',
  `address` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '地址',
  `site_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点id',
  `accessory_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '配件id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '父级id',
  `menu_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单名',
  `use_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型 MENU 菜单, BUTTON 按钮',
  `menu_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路由地址',
  `menu_component` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组件地址',
  `menu_icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图标',
  `menu_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限code',
  `common_auth` tinyint DEFAULT '0' COMMENT '公共权限 1是公共权限 默认为0',
  `sort` int DEFAULT '0' COMMENT '序号',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `menu_code` (`menu_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1001', '0', 'routes.menu.systemManagement.name', 'MENU', 'MENU', '/settings', NULL, 'ep:setting', 'settings', 0, 99, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100111', '1001', 'routes.menu.organizationalStructure.name', 'ROUTE', 'MENU', '/settings/setting/organization', NULL, 'fluent:organization-32-regular', 'organization', 0, 5, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011111', '100111', 'routes.menu.organizationalStructure.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:depart:findTree', 0, 4, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011112', '100111', 'routes.menu.organizationalStructure.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:depart:add', 0, 3, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011113', '100111', 'routes.menu.organizationalStructure.buttons.edit', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:depart:update', 0, 2, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011114', '100111', 'routes.menu.organizationalStructure.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:depart:delete', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100112', '1001', 'routes.menu.employeeManagement.name', 'ROUTE', 'MENU', '/settings/setting/account', NULL, 'la:user-cog', 'account', 0, 4, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011211', '100112', 'routes.menu.employeeManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:page', 0, 3, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011212', '100112', 'routes.menu.employeeManagement.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:add', 0, 2, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011213', '100112', 'routes.menu.employeeManagement.buttons.edit', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:update', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011214', '100112', 'routes.menu.employeeManagement.buttons.disable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:disable', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011215', '100112', 'routes.menu.employeeManagement.buttons.enable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:enable', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011216', '100112', 'routes.menu.employeeManagement.buttons.restPassword', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:restPassword', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011218', '100112', 'routes.menu.employeeManagement.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:user:delete', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100113', '1001', 'routes.menu.roleManagement.name', 'ROUTE', 'MENU', '/settings/setting/rolelimit', NULL, 'icons8:add-user', 'rolelimit', 0, 3, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011311', '100113', 'routes.menu.roleManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:page', 0, 3, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011312', '100113', 'routes.menu.roleManagement.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:add', 0, 2, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011313', '100113', 'routes.menu.roleManagement.buttons.edit', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:update', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011314', '100113', 'routes.menu.roleManagement.buttons.enable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:enable', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011315', '100113', 'routes.menu.roleManagement.buttons.disable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:disable', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011316', '100113', 'routes.menu.roleManagement.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:role:delete', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100114', '1001', 'routes.menu.logManagement.name', 'ROUTE', 'MENU', '/settings/setting/log', NULL, 'icon-park-outline:log', 'log', 0, 2, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011411', '100114', 'routes.menu.logManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:log:page', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100115', '1001', 'routes.menu.dataDictionary.name', 'ROUTE', 'MENU', '/settings/setting/datadictionary', NULL, 'material-symbols-light:dictionary-outline', 'datadictionary', 0, 1, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011511', '100115', 'routes.menu.dataDictionary.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:findChildrenPage', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011512', '100115', 'routes.menu.dataDictionary.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:add', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011513', '100115', 'routes.menu.dataDictionary.buttons.edit', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:update', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011514', '100115', 'routes.menu.dataDictionary.buttons.enable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:enable', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011515', '100115', 'routes.menu.dataDictionary.buttons.disable', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:disable', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011516', '100115', 'routes.menu.dataDictionary.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:dict:delete', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100116', '1001', 'routes.menu.systemConfiguration.name', 'ROUTE', 'MENU', '/settings/setting/systemConfiguration', NULL, 'fluent-mdl2:auto-deploy-settings', 'systemConfiguration', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011611', '100116', 'routes.menu.systemConfiguration.buttons.emailConfig', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:email:emailConfig', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '邮件配置');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('10011612', '100116', 'routes.menu.systemConfiguration.buttons.sysConfig', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:sys:config:update', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '系统配置');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002', '0', 'routes.menu.leaseManagement.name', 'ROUTE', 'MENU', '/lease', NULL, 'bi:house-gear', 'lease', 0, 140, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100211', '1002', 'routes.menu.leaseManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:find:rentalList', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002111', '1002', 'routes.menu.leaseDetails.name', 'DETAILS', 'MENU', '/lease/details', NULL, NULL, 'leaseDetails', 0, 150, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002111111', '1002111', 'routes.menu.leaseDetails.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:add:rentalDevice', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002111112', '1002111', 'routes.menu.leaseDetails.buttons.delay', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:postpone', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002111113', '1002111', 'routes.menu.leaseDetails.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:del', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1002111114', '1002111', 'routes.menu.leaseDetails.buttons.end', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:endService', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100212', '1002', 'routes.menu.leaseManagement.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:rental:find:rentalRoomDevice', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1004', '0', 'routes.menu.siteManagement.name', 'ROUTE', 'MENU', '/site', NULL, 'gis:position-o', 'site', 0, 160, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100411', '1004', 'routes.menu.siteManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:site:page', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100412', '1004', 'routes.menu.siteManagement.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:site:add', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100413', '1004', 'routes.menu.siteManagement.buttons.update', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:site:update', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100414', '1004', 'routes.menu.siteManagement.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:site:delete', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100415', '1004', 'routes.menu.siteManagement.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:site:detail', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1005', '1004', 'routes.menu.siteDetails.name', 'DETAILS', 'MENU', '/site/details', NULL, NULL, 'siteDetails', 0, 170, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100511', '1005', 'routes.menu.siteDetails.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:page', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100512', '1005', 'routes.menu.siteDetails.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:add', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100513', '1005', 'routes.menu.siteDetails.buttons.update', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:update', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100514', '1005', 'routes.menu.siteDetails.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:delete', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100515', '1005', 'routes.menu.siteDetails.buttons.deviceSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:set', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100516', '1005', 'routes.menu.siteDetails.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:device:detail', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1006', '1005', 'routes.menu.deviceDetails.name', 'DETAILS', 'MENU', '/device/details', NULL, NULL, 'deviceDetails', 0, 180, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100611', '1006', 'routes.menu.deviceDetails.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:findAccessoryPage', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100612', '1006', 'routes.menu.deviceDetails.buttons.add', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:addAccessory', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100613', '1006', 'routes.menu.deviceDetails.buttons.update', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:updAccessory', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100614', '1006', 'routes.menu.deviceDetails.buttons.delete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:delAccessory', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100615', '1006', 'routes.menu.deviceDetails.buttons.smokeSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:set', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '烟感开关设置');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100616', '1006', 'routes.menu.deviceDetails.buttons.pirSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:setPIRAccessoryInfo', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '设置PIR相机信息');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100617', '1006', 'routes.menu.deviceDetails.buttons.outdoorSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:setODAlarmBellAccessoryInfo', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '设置室外警号');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100618', '1006', 'routes.menu.deviceDetails.buttons.sensorPlusSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:setDoorDetectorPlusAccessoryInfo', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '设置升级⻔磁信息');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100619', '1006', 'routes.menu.deviceDetails.buttons.sensorSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:setDoorDetectorAccessoryInfo', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '设置⻔磁信息');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100620', '1006', 'routes.menu.deviceDetails.buttons.pairSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:setAccessoryPair', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '挂载配件');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100621', '1006', 'routes.menu.deviceDetails.buttons.keyboardSet', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:keyboard:set', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '无线键盘开关设置');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100622', '1006', 'routes.menu.deviceDetails.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:accessory:detail', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, '详情');
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100623', '1006', 'routes.menu.deviceDetails.buttons.roomQuery', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:room:roomPage', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100624', '1006', 'routes.menu.deviceDetails.buttons.roomAdd', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:room:add', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100625', '1006', 'routes.menu.deviceDetails.buttons.roomUpdate', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:room:update', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100626', '1006', 'routes.menu.deviceDetails.buttons.roomDelete', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:room:delete', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100627', '1006', 'routes.menu.deviceDetails.buttons.roomUpdateMode', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:room:updateMode', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1007', '0', 'routes.menu.faultCenter.name', 'ROUTE', 'MENU', '/fault', NULL, 'fluent:text-bullet-list-square-warning-20-regular', 'fault', 0, 190, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100711', '1007', 'routes.menu.faultCenter.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:fault:page', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100712', '1007', 'routes.menu.faultCenter.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:fault:detail', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1008', '0', 'routes.menu.alarmManagement.name', 'ROUTE', 'MENU', '/failure', NULL, 'ri:alarm-warning-line', 'failure', 0, 200, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100811', '1008', 'routes.menu.alarmManagement.buttons.query', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:alarm:page', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('100812', '1008', 'routes.menu.alarmManagement.buttons.detail', 'BUTTON', 'BUTTON', NULL, NULL, NULL, 'backend:business:alarm:detail', 0, 0, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `parent_id`, `menu_name`, `use_type`, `menu_type`, `menu_url`, `menu_component`, `menu_icon`, `menu_code`, `common_auth`, `sort`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1009', '0', 'routes.menu.home.name', 'ROUTE', 'MENU', '/home', NULL, 'iconamoon:home', 'home', 0, 210, 'ENABLE', NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色id',
  `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色名',
  `role_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色编码',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `role_code` (`role_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `role_name`, `role_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1', 'Super Admin', 'admin', 'ENABLE', 'admin', '2024-03-28 16:43:27', 'admin', '2024-03-28 16:50:35', 'Super Admin');
INSERT INTO `sys_role` (`id`, `role_name`, `role_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('371e198b352ba5ced1ca3dea0ae0a732', 'Installer', 'installer', 'ENABLE', NULL, NULL, '154651@163.com', '2024-08-26 16:06:13', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1表示全选2表示不全选',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('012407eb6879a24df11ea106fa2f2a0f', '1', '100515', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('049b728a1ce36a0939640b25e3894318', '1', '10011111', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('05acee81753adf84ac61d3d4be01b3ca', '1', '100619', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('076d022e305534ed0ea3cb2301b72931', '1', '1002111114', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('07c1e90610e214008043085d39f20c5c', '1', '100513', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('0d97e1684613829a6bf22b9c0bf3d152', '1', '100116', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('1306faf377f3fdece07a2f71c3b1227a', '1', '1009', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('143270108b430b68d275a9154505360d', '1', '1002111', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('180f7e1e8338271805690b7aada27645', '1', '100115', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('199b883973fc49071aba5d5d65f6c6c9', '1', '1008', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('1d212cf2e75ec730bc29c6a3120bbaa6', '1', '100626', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('27ece8df9d97323ca4bb592a04805ad0', '1', '10011314', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('3169fb447e9805776896077cca27aab8', '1', '100615', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('33367c5f99f84a7e5b8ad9d600559bdb', '1', '100613', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('35e442a96dde1719817c8e56e43f5015', '1', '1002', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('394c939286c6abbc8447e9fe8f1094ce', '1', '100625', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('3c5375cd9e7f9693cfe630744ae9f280', '1', '100111', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('3c863e446332b706b7080cccbdc28bc6', '1', '10011311', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('3c86ab84e97cadc3eeacde54181d8ab4', '1', '1002111113', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('3e96007ea4c3a57eaf8c7f643300244b', '1', '10011612', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('434cc890e523f153b474d91dd91fa1e8', '1', '100624', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('4350a1b5917035771a603e90de035a82', '1', '100114', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('442524caecf7e13ef6ee320615035ba3', '1', '100414', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('449ae31d2ac9d6b6da059ac7e0fa08ce', '1', '100611', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('480371f98f8afca12c6c341b8a2ad8f9', '1', '100211', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('4916ad89241bba09bc9b9311c6f3b56b', '1', '10011211', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('4d0ce8b1f29ccc86635e874dc6c30586', '1', '100618', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('4d141ff755e53549da270066f5c783cc', '1', '10011212', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('4fb49e70ed448077407e5f1d4175cdc9', '1', '100623', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('559e9581d70fb8d9efd6a53a2d47764b', '1', '10011313', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('569f15d1c063a5e6419667d456225da0', '1', '100212', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('5a0d731f30bd07a383069db14950981a', '1', '10011214', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('5b237aa1eb8d1ab5f2cac72c2e09b602', '1', '100622', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('5fd9c585c6230e9da6573c40a45970ef', '1', '1001', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('627aafd05f14ac6c3fde2e0c4aec4b73', '1', '10011215', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('67240939e3b26ddf599ba1981719503f', '1', '10011411', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('725af7bb5178d756437d3b219aa8f188', '1', '100621', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('72613face0eb318dfb3d8bfbae5e211a', '1', '100627', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('7856aaf74517e4d94e39b67519691ca4', '1', '1007', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('78fb4824f42ab6924a37c137b3d6830e', '1', '10011218', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('7fed3662f6110e783101af267a211ac3', '1', '100620', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('86a1054e640d1fc56ff0d8da58e19f82', '1', '10011512', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('98363cc1f8c447f5fe7c58f67a995ce9', '1', '100712', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('9d0b264239422badb0d7f902ace101ee', '1', '10011316', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('9e48fbdcc5c4614b0ce5b5b3af3178f2', '1', '10011514', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('a2512a55716a9f1a6ecde6d4c077e987', '1', '100711', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('a8bbedf807b6ee7c36d961c28f62286e', '1', '10011611', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('aa341062ae2d72812994d9cd2dfd3892', '1', '10011112', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('b4c899b3529150c185bd4e935d8e95be', '1', '100514', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('b550d6ce4edfeab4c9ebb5b3274422ef', '1', '10011312', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('b9791b5a9eabcade4084a694200d22fa', '1', '100113', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('ba4e0df4109be845a0560ee56d359823', '1', '10011513', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('bc2f5639ba36cc1819a6f0c7e8a0d967', '1', '100415', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('bf3d1b635391bd0593f3e24af63d5578', '1', '10011315', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('bf4a9ef5978750fd592d94b1b1790044', '1', '100614', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('c44f52b4502d8d49ee6859bda4c2248e', '1', '100812', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('c5b3b542e0acd2e0f3ed15e9aca26f24', '1', '10011516', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('c8474982487d03462ac4577d68f8f2fd', '1', '1002111112', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d1aab1df13cdf3b2b649a7498c046be0', '1', '100617', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d25aaa90684d0e656b2449695bbdfc85', '1', '100411', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d2aaac2b9af3319b57553981d0a0e0ad', '1', '100112', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d4ba8570273a4582d8b049359e3341fe', '1', '1002111111', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d4d1110676f8517372d5adbad3a3c36a', '1', '10011511', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('d98c075d29c2e72ee3af4e93e6c82fe3', '1', '1005', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('dc559734e7bdc1ea20b94f6fa18e2b7e', '1', '100511', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('e1b98cadb51a80c07bca822babd52d3d', '1', '100413', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('e2f2212e6d00d12d8da29b3f7e335ae9', '1', '1004', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('eb823706aaf6ca5d888db125e832b438', '1', '100516', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('ebb522926df48fa0d007786f52a33b20', '1', '100412', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('ec2b37a94e4eb13dad43fd290fa47119', '1', '10011114', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('ecdcc915d6126dc55d84d6257afdd84e', '1', '10011213', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('efb1746593872fa59adb520675fbcba1', '1', '100811', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f081af885458dc4ff360ee12c83c6702', '1', '10011216', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f0ffd657cc9d87269f8c7b1da1c920fd', '1', '100612', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f1541606c6c634730acab8999ea268f8', '1', '10011515', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f1657acf9923ffb85b733cc92bb16e18', '1', '100512', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f4bfaf9d9b72f6beab88ab581b7deb9c', '1', '1006', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f65af734760c2df75e7a3c32a5dff70c', '1', '10011113', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `type`) VALUES ('f8d3be2986eedbb3c648e6a8ca33efc4', '1', '100616', '610224625@qq.com', '2024-08-26 21:27:40', NULL, NULL, NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户主键',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `avatar` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户头像地址',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '邮箱',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户昵称',
  `position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '职务',
  `wx_openid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信openid',
  `wx_unionid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信unionid',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'ENABLE' COMMENT '启用 ENABLE 关闭 DISABLE',
  `id_card` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证',
  `ykz_userid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '愉快政userid',
  `type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户类型1市物业2区县3街道办4业委会',
  `region_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区域',
  `stree_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '街道',
  `community_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '小区',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '区号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `user_name` (`username`) USING BTREE,
  UNIQUE KEY `mobile` (`mobile`) USING BTREE,
  KEY `wx_openid` (`wx_openid`) USING BTREE,
  KEY `wx_unionid` (`wx_unionid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `password`, `avatar`, `mobile`, `email`, `nickname`, `position`, `wx_openid`, `wx_unionid`, `status`, `id_card`, `ykz_userid`, `type`, `region_code`, `stree_id`, `community_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`, `country_code`) VALUES ('1', 'admin', '$2a$10$zlf2nPAYOMriAyTM6HEU8O26i185ptVaA6ZA7hPcqk8KVCKLIDoSC', NULL, '15084311008', 'admin', 'admin', NULL, NULL, NULL, 'ENABLE', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'admin', '2024-03-28 17:09:32', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_depart
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_depart`;
CREATE TABLE `sys_user_depart` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
  `depart_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部门id',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户与部门关联表';

-- ----------------------------
-- Records of sys_user_depart
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
  `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '角色id',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户与角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`, `create_by`, `create_time`, `update_by`, `update_time`, `description`) VALUES ('1', '1', '1', 'admin', '2024-03-28 17:43:43', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for time_zone_dict
-- ----------------------------
DROP TABLE IF EXISTS `time_zone_dict`;
CREATE TABLE `time_zone_dict` (
  `area_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'dolyink时区',
  `time_zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'java对照'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of time_zone_dict
-- ----------------------------
BEGIN;
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('InternationalDateLineWest', 'Etc/GMT+12');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC-11', 'Etc/GMT+11');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('AleutianIslands', 'America/Adak');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('MarquesasIslands', 'Pacific/Marquesas');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Alaska', 'America/Anchorage');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC-09', 'America/Anchorage');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('LowerCalifornia', 'America/Tijuana');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC-08', 'America/Los_Angeles');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Pacifictime', 'America/Los_Angeles');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Arizona', 'America/Phoenix');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chihuahua', 'America/Chihuahua');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Mountaintime', 'America/Denver');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Yukon', 'America/Whitehorse');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('CentralAmerica', 'America/Guatemala');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Middletime', '');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('EasterIsland', 'Pacific/Easter');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Guadalajara', 'America/Mexico_City');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Saskatchewan', 'America/Regina');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Bogota', 'America/Bogota');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chetumal', 'America/Cancun');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Easterntime', 'America/Jamaica');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Haiti', 'America/Port-au-Prince');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Havana', 'America/Havana');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Indiana', 'America/Indiana/Indianapolis');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Asuncion', 'America/Asuncion');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Atlantictime', 'America/Halifax');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Caracas', 'America/Caracas');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Cuiaba', 'America/Cuiaba');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Georgetown', 'America/Guyana');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Santiago', 'America/Santiago');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Turks', 'America/Turks_Caicos');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Newfoundland', 'America/St_Johns');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Araguaina', 'America/Araguaina');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Brasilia', 'America/Brasilia');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Cayenne', 'America/Cayenne');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('BuenosAires', 'America/Argentina/Buenos_Aires');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Greenland', 'America/Godthab');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('MondVeeDya', 'America/Montevideo');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('SaintPierre', 'America/St_Pierre');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('PuntaArenas', 'America/Punta_Arenas');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Salvatore', 'America/Bahia');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC-02', 'Atlantic/South_Georgia');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Azores', 'Atlantic/Azores');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('CaboVerdeIslands', 'Atlantic/Cape_Verde');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC-0', 'Africa/Casablanca');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Casablanca', 'Africa/Casablanca');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Dublin', 'Europe/Dublin');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Monrovia', 'Africa/Monrovia');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('SaoTome', 'Africa/Sao_Tome');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Amsterdam', 'Europe/Amsterdam');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Belgrade', 'Europe/Belgrade');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Brussels', 'Europe/Brussels');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Sarajevo', 'Europe/Sarajevo');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('CentralandwesternAfrica', 'Africa/Lagos');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('WindhoekWindhoek', 'Africa/Windhoek');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Amman', 'Asia/Amman');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Athens', 'Europe/Athens');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Beirut', 'Asia/Beirut');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Cairo', 'Africa/Cairo');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chisinau', 'Europe/Chisinau');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Damascus', 'Asia/Damascus');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Gaza', 'Asia/Gaza');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Helsinki', 'Europe/Helsinki');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Jerusalem', 'Asia/JerusalemAsia/Jerusalem');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Kaliningrad', 'Europe/Kaliningrad');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Juba', 'Africa/Juba');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Khartoum', 'Africa/Khartoum');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Tripoli', 'Africa/Tripoli');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('EasternEurope', 'Europe/Helsinki');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Baghdad', 'Asia/Baghdad');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Istanbul', 'Europe/Istanbul');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Kuwait', 'Asia/Kuwait');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Minsk', 'Europe/Minsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Moscow', 'Europe/Moscow');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Nairobi', 'Africa/Nairobi');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Tehran', 'Asia/Tehran');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('AbuDhabi', 'Asia/Dubai');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Astrakhan', 'Europe/Astrakhan');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Baku', 'Asia/Baku');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Izhevsk', 'Europe/Samara');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('PortLouis', 'Indian/Mauritius');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Saratov', 'Europe/Saratov');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Tbilisi', 'Asia/Tbilisi');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Yerevan', 'Asia/Yerevan');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Kabul', 'Asia/KabulAsia/Kabul');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Ashkhabad', 'Asia/Ashgabat');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Ekaterinburg', 'Asia/Yekaterinburg');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Islamabad', 'Asia/Karachi');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Qyzylorda', 'Asia/Qyzylorda');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chennai', 'Asia/Kolkata');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('SriJayawardenapura', 'Asia/Colombo');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Kathmandu', 'Asia/Kathmandu');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Astana', 'Asia/Almaty');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Dhaka', 'Asia/Dhaka');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Omsk', 'Asia/Omsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Yangon', 'Asia/Yangon');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Bangkok', 'Asia/Bangkok');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Barnaul', 'Asia/Barnaul');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Hovd', 'Asia/Hovd');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Krasnoyarsk', 'Asia/Krasnoyarsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Novosibirsk', 'Asia/Novosibirsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Tomsk', 'Asia/Tomsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Beijing', 'Asia/Shanghai');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Irkutsk', 'Asia/Irkutsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('KualaLumpur', 'Asia/Kuala_Lumpur');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Perth', 'Australia/Perth');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Ulaanbaatar', 'Asia/Ulaanbaatar');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Pyongyang', 'Asia/Pyongyang');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Eucla', 'Australia/Eucla');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chita', 'Asia/Chita');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Osaka', 'Asia/Tokyo');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Seoul', 'Asia/Seoul');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Yakutsk', 'Asia/Yakutsk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Adelaide', 'Australia/Adelaide');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Darwin', 'Australia/Darwin');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Brisbane', 'Australia/Brisbane');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Canberra', 'Australia/Sydney');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Guam', 'Pacific/Guam');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Hobart', 'Australia/Hobart');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Vladivostok', 'Asia/Vladivostok');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('LordHoweIsland', 'Australia/Lord_Howe');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('BougainvilleIsland', 'Pacific/Bougainville');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Chokurdakh', 'Asia/Khandyga');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Magadan', 'Asia/Magadan');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('NorfolkIsland', 'Pacific/Norfolk');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Sakhalin', 'Asia/Sakhalin');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('SolomonIslands', 'Pacific/Guadalcanal');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Anadyr', 'Asia/Anadyr');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Auckland', 'Pacific/Auckland');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC+12', 'Pacific/Fiji');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Fiji', 'Pacific/Fiji');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('ChathamIslands', 'Pacific/Chatham');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('UTC+13', 'Pacific/Tongatapu');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Nukualofa', 'Pacific/Tongatapu');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('Samoa', 'Pacific/Apia');
INSERT INTO `time_zone_dict` (`area_desc`, `time_zone`) VALUES ('KiritimatiIsland', 'Pacific/Kiritimati');
COMMIT;

-- ----------------------------
-- Table structure for user_site
-- ----------------------------
DROP TABLE IF EXISTS `user_site`;
CREATE TABLE `user_site` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户id',
  `site_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '站点id',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户站点表';

-- ----------------------------
-- Records of user_site
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
